﻿CREATE TABLE [dbo].[GLTemp] (
    [Id]              INT          IDENTITY (1, 1) NOT NULL,
    [Date]            DATETIME     NOT NULL,
    [Entity]          VARCHAR (4)  NOT NULL,
    [Filial]          VARCHAR (4)  NOT NULL,
    [Subsidiary]      VARCHAR (12) NOT NULL,
    [Money]           DECIMAL (3)  NOT NULL,
    [Sector]          VARCHAR (4)  NOT NULL,
    [Line]            VARCHAR (6)  NULL,
    [Value]           DECIMAL (18) NOT NULL,
    [TransactionType] CHAR (1)     NOT NULL,
    [TransactionCode] DECIMAL (5)  NOT NULL,
    [OPInput]         VARCHAR (4)  NULL,
    [OPAuth]          VARCHAR (4)  NULL,
    [Module]          VARCHAR (4)  NULL,
    [Prove]           VARCHAR (5)  NOT NULL,
    [EventCode]       VARCHAR (7)  NULL,
    [EventNumber]     VARCHAR (10) NULL,
    [ContabilityDate] DATETIME     NULL,
    [HistoricOne]     VARCHAR (65) NULL,
    [HistoricTwo]     VARCHAR (65) NULL,
    [ReportFlag]      BIT          NULL
);

